CREATE PROCEDURE [dbo].[asi_UpdatePublishedRuleSource]

@objectName nvarchar(100),
@source ntext,
@debugEnabled bit = 0

AS

IF EXISTS(SELECT 1 FROM RuleSourcePublish WHERE RuleName = @objectName)
    BEGIN
        UPDATE RuleSourcePublish SET RuleCode = @source, IsDebugEnabled = @debugEnabled, DebugFileName = NULL WHERE RuleName = @objectName
    END
ELSE
    BEGIN
        INSERT RuleSourcePublish (RuleName, RuleCode, IsDebugEnabled) VALUES (@objectName, @source, @debugEnabled)
    END

GO